FaLoan

Logical Entity Name | FaLoan
Default Table Name | FaLoan
Physical Only | NO
Owner | dbo
Definition |
Note |

FaLoan Columns

ColumnName | Domain | Datatype | NULL | Definition
FaLoanId |  | int | NO |
fastudentaidid |  | int | NO |
directloanid |  | char(21) | YES |
schooldloanid |  | char(6) | YES |
borrowerssn |  | char(16) | YES |
borrowerlastname |  | nvarchar(128) | YES |
borrowerfirstname |  | nvarchar(128) | YES |
borrowermi |  | char(1) | YES |
borrowercity |  | char(16) | YES |
borrowerstate |  | char(2) | YES |
borrowerzip |  | char(14) | YES |
borrowerlocaladdress |  | text | YES |
borrowerlocalcity |  | char(16) | YES |
borrowerlocalstate |  | char(2) | YES |
borrowerlocalzip |  | char(10) | YES |
borrowerphone |  | char(16) | YES |
borrowerdriverlicensenumber |  | char(20) | YES |
borrowerdriverlicensestate |  | char(2) | YES |
borrowerdob |  | datetime | YES |
borrowercitizenstatus |  | char(1) | YES |
borroweralienid |  | char(9) | YES |
borrowerdefaultonloans |  | char(1) | YES |
borroweremployer |  | char(30) | YES |
borroweremployeraddr |  | char(35) | YES |
borroweremployercity |  | char(20) | YES |
borroweremployerstate |  | char(2) | YES |
borroweremployerzip |  | char(10) | YES |
borroweremployerphone |  | char(16) | YES |
borrowertimeatemployer |  | numeric(18, 2) | YES |
loanamountapproved |  | money | YES |
loanamountrequested |  | money | YES |
originationbatchid |  | varchar(30) | YES |
originationstatus |  | char(1) | YES |
originationdate |  | datetime | YES |
dateoriginationlastextracted |  | datetime | YES |
acknowledgedate |  | datetime | YES |
unsubeligibilityflag |  | char(1) | YES |
unsubeligibilityuptoheal |  | char(1) | YES |
bookstatus |  | char(1) | YES |
bookdate |  | datetime | YES |
pnprintindicator |  | char(1) | YES |
pnsignedbystudent |  | char(1) | YES |
pnsignedbyborrower |  | char(1) | YES |
datesignedpnreceived |  | datetime | YES |
pnalteredbyborrower |  | char(1) | YES |
pnstatus |  | char(1) | YES |
datepnprinted |  | datetime | YES |
datepnsigned |  | datetime | YES |
pnprintsequencenum |  | int | YES |
pnacceptedamount |  | int | YES |
pnacceptedamountdate |  | datetime | YES |
pndirectloanid |  | char(21) | YES |
pnacceptedsequencenum |  | int | YES |
pnacknowledgebatchid |  | char(23) | YES |
pnacknowledgedate |  | datetime | YES |
pnincludeonmanifest |  | bit | NO |
manifestbatchid |  | char(23) | YES |
manifestdate |  | datetime | YES |
pluscreditdecisionstatus |  | char(1) | YES |
pluscreditdecisiondate |  | datetime | YES |
studentssn |  | char(11) | YES |
studentfirstname |  | nvarchar(128) | YES |
studentlastname |  | nvarchar(128) | YES |
studentmi |  | char(1) | YES |
studentcitizenstatus |  | char(1) | YES |
studentalienid |  | char(9) | YES |
studentdob |  | datetime | YES |
studentyearincollege |  | char(2) | YES |
studentdefaultonloans |  | char(1) | YES |
addresschangedate |  | datetime | YES |
localaddresschangedate |  | datetime | YES |
ssnchangedate |  | datetime | YES |
dobchangedate |  | datetime | YES |
userid |  | int | NO |
dateadded |  | datetime | NO |
datelstmod |  | datetime | NO |
ts |  | timestamp | NO |
AltBorrowerStudentLoanDebt |  | money | YES |
borrowerInterestIndicator |  | char(1) | YES |
borrowerLegalResState |  | char(2) | YES |
borrowerLegalResStateDate |  | datetime | YES |
borrowerOutstandingLoans |  | char(1) | YES |
borrowerReferenceCode |  | char(1) | YES |
CLApplicationStatus |  | char(1) | YES |
CommonLineLoanID |  | char(17) | YES |
DeferRequestCode |  | char(1) | YES |
EFTAuthorization |  | char(1) | YES |
FaRecipientID |  | int | YES |
LoanAmountCertified |  | money | YES |
ProcessingCode |  | char(2) | YES |
PromNoteDeliveryCode |  | char(1) | YES |
RecordTypeIndicatorCode |  | char(1) | YES |
SerialLoanCode |  | char(1) | YES |
StudentSignatureCode |  | char(1) | YES |
DateDisclosurePrinted |  | datetime | YES |
OriginationFeePct |  | money | NO |
PrintDisclosureAtLOC |  | bit | NO |
CLApplicationStatusDate |  | datetime | YES |
CLAppLoanPhase |  | char(4) | YES |
CLAppLoanPhaseDate |  | datetime | YES |
CommonLineLoanSeqNum |  | char(2) | YES |
GuaranteeReductionCode |  | char(2) | YES |
LoanAmountCertifiedDate |  | datetime | YES |
LoanAmountGuaranteed |  | money | YES |
LoanGuaranteeDate |  | datetime | YES |
Email |  | varchar(128) | YES |
InterestRebatePct |  | money | YES |
MPNIndicator |  | char(1) | YES |
DateLastPmt |  | datetime | YES |
DeliquentDate |  | datetime | YES |
ExpirationDate |  | datetime | YES |
GraceDays |  | numeric(9, 0) | YES |
LMLoanStatusEffectiveDate |  | datetime | YES |
LMLoanStatusID |  | int | YES |
LoanBalance |  | money | YES |
LoanInterest |  | numeric(9, 2) | YES |
NumberPayments |  | numeric(9, 0) | YES |
PaymentAmount |  | money | YES |
PreClaimsDate |  | datetime | YES |
RepayDate |  | datetime | YES |
MPNType |  | char(1) | YES |
OrigRejectCodes |  | char(75) | YES |
EndorserAmt |  | money | NO |
BorrowerIdentifier |  | varchar(44) | YES |
IdentifierChanged |  | bit | NO |
PrintDisclosureCode |  | char(1) | YES |
BorrowerAddress |  | varchar(2000) | YES |
DefaultDate |  | datetime | YES |
LMDefaultRateUsageCodeID |  | int | YES |
PreProfessionalCourseworkIndicator |  | bit | NO |
MPNExpirationDate |  | datetime | YES |
EntranceCounseling |  | bit | NO |
LoanCreateDate |  | datetime | YES |
ApplicationID |  | char(10) | YES |
ApplicationCompleteDate |  | datetime | YES |
ApplicationLoanAmount |  | numeric(11, 2) | YES |
CreditBalanceOption |  | char(1) | YES |
CreditActionChoice |  | char(1) | YES |
CreditAppealStatus |  | char(1) | YES |
MaximumLoanIndicator |  | char(1) | YES |
CreditDecisionExpirationDate |  | datetime | YES |
OriginalCreditDecisionStatus |  | char(1) | YES |
DefermentOption |  | bit | YES |
ParentRejectedForPLUS |  | bit | NO |
SpecialProgramType |  | char(1) | NO |
AdminRelief |  | bit | NO |
DirectLoanCOA |  | numeric(19, 4) | YES |
borrowermiddlename |  | nvarchar(35) | YES |
borrowersuffix |  | nvarchar(10) | YES |
studentmiddlename |  | nvarchar(35) | YES |
studentsuffix |  | nvarchar(10) | YES |

FaLoan Primary and Unique Keys

Key Name | Key Type | Keys
FaLoan_FaStudentAidID_CLApplicationStatus_ProcessingCode_FaLoanID_U_N_IDX | Index | fastudentaidid, CLApplicationStatus, ProcessingCode, FaLoanId
FaLoan_faloanid_U_C_IDX | PrimaryKey | FaLoanId

FaLoan Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
FaStudentAid | Non-Identifying | One To Zero or More | FK_FaLoan_fastudentaidid_FaStudentAid_FaStudentAidID |  |  | fastudentaidid | NO | YES
LMDefaultRateUsageCode | Non-Identifying | Zero or One to Zero or More | FK_FALoan_LMDefaultRateUsageCodeID_LMDefaultRateUsageCode_LMDefaultRateUsageCodeID |  |  | LMDefaultRateUsageCodeID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FaCommonLineResponse | Non-Identifying | One To Zero or More | FK_FaCommonLineResponse_FaLoanID_FaLoan_faloanid |  |  |  | NO | YES
FaLoanApplication | Non-Identifying | One To Zero or More | FK_FaLoanApplication_FaLoanID_FaLoan_FaLoanID |  |  |  | NO | YES
FaLoanCommonLineChangeSendLog | Non-Identifying | One To Zero or More | FK_FaLoanCLChangeSendLog_FaLoanId_FaLoan_FaLoanId |  |  |  | NO | YES
FaLoanDisclosurePrintHistory | Non-Identifying | One To Zero or More | FK_FaLoanDisclosurePrintHistoryFaLoanId_FaLoanFaLoanId |  |  |  | NO | YES

FaLoan Check Constraints

Check Constraint Name | CheckConstraint

FaLoan Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

FaLoan Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAwardLoan | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaLoan | NO |  |  |

FaLoan Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaLoan Data Movement Rules

Name | Type | Rule Text/Value